Use DROP TABLE statement to delete any existing table in MySQL database. This deletes all table data and structure both.
Syntax:
DROP TABLEtable_name;
Example – MySQL Drop Table
For example, I have table users in the database. I need to remove its data completely with structure. Login to your MySQL server and select database. Now execute below query to remove the database.
DROP TABLE users;